package test.testcase.dao;

import test.utils.JsonResult;
import test.utils.Mysql;

public class JenkinsDao {
	
	public static JsonResult save(String projectid, String folder, String jobname, String host, String username, String pwd) {
		return Mysql.excute("replace into jenkins (projectid, folder, jobname, host, username, token)values("+projectid+",'"+folder+"','"+jobname+"','"+host+"','"+username+"','"+pwd+"')");
	}
	
	public static JsonResult getJenkinsInfo(String projectid) {
		return Mysql.select("select * from jenkins where projectid="+projectid);
	}
	
}
